-
Re: COUNTIFS - Projects that equal a certain value and are CHILDREN
After some more research I found that you can't use the CHILDREN function when referencing another sheet. So to make this work, I have added a Helper column with checkboxes for the Parent rows and us…1 · -
Re: Reference row if its the newest entry
I was able to figure this out and instead of deleting my post, I wanted to share the solution so that it can be refined and reused by others. In Sheet 2 I used this formula in each column (in this ca…1 ·